CREATE TABLE daycare.FamilyDocuments
  (
   FamilyDocumentId INT NOT NULL
                        PRIMARY KEY
                        IDENTITY(1,1)
 , FamilyId INT NOT NULL
 , DocumentId INT NOT NULL
 , ExpirationDate DATE
 , DocumentName VARCHAR(100) NOT NULL
 , FilePath VARCHAR(200) NOT NULL
  )
ALTER TABLE daycare.FamilyDocuments ADD CONSTRAINT FK_FamilyDocuments_Families FOREIGN KEY(FamilyId) REFERENCES daycare.Families(FamilyId)
ALTER TABLE daycare.FamilyDocuments ADD CONSTRAINT FK_FamilyDocuments_Documents FOREIGN KEY(DocumentId) REFERENCES daycare.Documents(DocumentId)
GO